{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Trapezoidal Rule","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Trapezoidal Rule","index":0,"n_rows":122,"n_cols":14,"rows_kept":122,"cut":false,"hidden":false,"merged":[[8,1,8,9],[1,1,1,9],[3,1,3,9],[5,1,5,9],[6,1,6,9],[7,1,7,9]]}
[]
[null,"Simpson's Integration Rule"]
[null,null,null,null,null,null,null,null,null,null,null,null,"www.numerical-methods.com"]
[null,"This spreadsheet computes the approximation to an integral using the Simpson's integration rule."]
[null,null,null,null,null,null,null,null,null,null,null,null,"source","http://www.numerical-methods.com/integration/Simpson's Integration Rule.xlsm"]
[null,"The integral to be approximated is showm to the right and the function f(x) can be defined using Alt-F11.",null,null,null,null,null,null,null,null,null,null,"guide","http://www.numerical-methods.com/integration/Simpson's Integration Rule.htm"]
[null,"In this example f(x)=EXP(x). The limits a and b on the integral can be set in the yellow cells below."]
[null,"The number of subdomains n can also be set in yellow below. Note n must be even"]
[null,"Note that the number of function evaluations is 2n+1."]
[]
[null,null,"a=",0,null,"b=",1]
[]
[null,null," n= (max=50)",4,null,"h=",{"$f":"(b-a)/n","v":0.25}]
[]
[]
[null,null,null,"f(x^*)","weighting","weight*f"]
[null,"i","x_i"]
[]
[null,0,{"$f":"a","v":0},{"$f":"IF(B19<>\"\",f(C19),\"\")","v":1},1,{"$f":"IF(D19=\"\",\"\",E19*D19)","v":1}]
[null,1,{"$f":"IF(B20<>\"\",C19+hh/2,\"\")","v":0.125},{"$f":"IF(B20<>\"\",f(C20),\"\")","v":1.1331484530668263},{"$f":"IF(B20=\"\",\"\",4)","v":4},4.5325938122673053,"Integral using Simpson's rule =",null,null,{"$f":"hh*SUM(F19:F121)/6","v":1.718284154699897}]
[null,{"$f":"IF(B20<(2*n), B20+1,\"\")","v":2},{"$f":"IF(B21<>\"\",C20+hh/2,\"\")","v":0.25},{"$f":"IF(B21<>\"\",f(C21),\"\")","v":1.2840254166877414},{"$f":"IF(B22=\"\",IF(B21=\"\",\"\",1),2)","v":2},2.5680508333754828]
[null,{"$f":"IF(B21<(2*n), B21+1,\"\")","v":3},{"$f":"IF(B22<>\"\",C21+hh/2,\"\")","v":0.375},1.4549914146182013,{"$f":"IF(B22=\"\",\"\",4)","v":4},5.819965658472805]
[null,{"$f":"IF(B22<(2*n), B22+1,\"\")","v":4},{"$f":"IF(B23<>\"\",C22+hh/2,\"\")","v":0.5},1.6487212707001282,{"$f":"IF(B24=\"\",IF(B23=\"\",\"\",1),2)","v":2},3.2974425414002564]
[null,{"$f":"IF(B23<(2*n), B23+1,\"\")","v":5},{"$f":"IF(B24<>\"\",C23+hh/2,\"\")","v":0.625},1.8682459574322223,{"$f":"IF(B24=\"\",\"\",4)","v":4},{"$f":"IF(D24=\"\",\"\",E24*D24)","v":7.4729838297288893}]
[null,{"$f":"IF(B24<(2*n), B24+1,\"\")","v":6},{"$f":"IF(B25<>\"\",C24+hh/2,\"\")","v":0.75},2.1170000166126748,{"$f":"IF(B26=\"\",IF(B25=\"\",\"\",1),2)","v":2},{"$f":"IF(D25=\"\",\"\",E25*D25)","v":4.2340000332253496}]
[null,{"$f":"IF(B25<(2*n), B25+1,\"\")","v":7},{"$f":"IF(B26<>\"\",C25+hh/2,\"\")","v":0.875},2.3988752939670981,{"$f":"IF(B26=\"\",\"\",4)","v":4},9.5955011758683924]
[null,{"$f":"IF(B26<(2*n), B26+1,\"\")","v":8},{"$f":"IF(B27<>\"\",C26+hh/2,\"\")","v":1},2.7182818284590451,{"$f":"IF(B28=\"\",IF(B27=\"\",\"\",1),2)","v":1},2.7182818284590451]
[null,{"$f":"IF(B27<(2*n), B27+1,\"\")","v":""},{"$f":"IF(B28<>\"\",C27+hh/2,\"\")","v":""},"",{"$f":"IF(B28=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B28<(2*n), B28+1,\"\")","v":""},{"$f":"IF(B29<>\"\",C28+hh/2,\"\")","v":""},"",{"$f":"IF(B30=\"\",IF(B29=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B29<(2*n), B29+1,\"\")","v":""},{"$f":"IF(B30<>\"\",C29+hh/2,\"\")","v":""},"",{"$f":"IF(B30=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B30<(2*n), B30+1,\"\")","v":""},{"$f":"IF(B31<>\"\",C30+hh/2,\"\")","v":""},"",{"$f":"IF(B32=\"\",IF(B31=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B31<(2*n), B31+1,\"\")","v":""},{"$f":"IF(B32<>\"\",C31+hh/2,\"\")","v":""},"",{"$f":"IF(B32=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B32<(2*n), B32+1,\"\")","v":""},{"$f":"IF(B33<>\"\",C32+hh/2,\"\")","v":""},"",{"$f":"IF(B34=\"\",IF(B33=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B33<(2*n), B33+1,\"\")","v":""},{"$f":"IF(B34<>\"\",C33+hh/2,\"\")","v":""},"",{"$f":"IF(B34=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B34<(2*n), B34+1,\"\")","v":""},{"$f":"IF(B35<>\"\",C34+hh/2,\"\")","v":""},"",{"$f":"IF(B36=\"\",IF(B35=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B35<(2*n), B35+1,\"\")","v":""},{"$f":"IF(B36<>\"\",C35+hh/2,\"\")","v":""},"",{"$f":"IF(B36=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B36<(2*n), B36+1,\"\")","v":""},{"$f":"IF(B37<>\"\",C36+hh/2,\"\")","v":""},"",{"$f":"IF(B38=\"\",IF(B37=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B37<(2*n), B37+1,\"\")","v":""},{"$f":"IF(B38<>\"\",C37+hh/2,\"\")","v":""},"",{"$f":"IF(B38=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B38<(2*n), B38+1,\"\")","v":""},{"$f":"IF(B39<>\"\",C38+hh/2,\"\")","v":""},"",{"$f":"IF(B40=\"\",IF(B39=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B39<(2*n), B39+1,\"\")","v":""},{"$f":"IF(B40<>\"\",C39+hh/2,\"\")","v":""},"",{"$f":"IF(B40=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B40<(2*n), B40+1,\"\")","v":""},{"$f":"IF(B41<>\"\",C40+hh/2,\"\")","v":""},"",{"$f":"IF(B42=\"\",IF(B41=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B41<(2*n), B41+1,\"\")","v":""},{"$f":"IF(B42<>\"\",C41+hh/2,\"\")","v":""},"",{"$f":"IF(B42=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B42<(2*n), B42+1,\"\")","v":""},{"$f":"IF(B43<>\"\",C42+hh/2,\"\")","v":""},"",{"$f":"IF(B44=\"\",IF(B43=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B43<(2*n), B43+1,\"\")","v":""},{"$f":"IF(B44<>\"\",C43+hh/2,\"\")","v":""},"",{"$f":"IF(B44=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B44<(2*n), B44+1,\"\")","v":""},{"$f":"IF(B45<>\"\",C44+hh/2,\"\")","v":""},"",{"$f":"IF(B46=\"\",IF(B45=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B45<(2*n), B45+1,\"\")","v":""},{"$f":"IF(B46<>\"\",C45+hh/2,\"\")","v":""},"",{"$f":"IF(B46=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B46<(2*n), B46+1,\"\")","v":""},{"$f":"IF(B47<>\"\",C46+hh/2,\"\")","v":""},"",{"$f":"IF(B48=\"\",IF(B47=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B47<(2*n), B47+1,\"\")","v":""},{"$f":"IF(B48<>\"\",C47+hh/2,\"\")","v":""},"",{"$f":"IF(B48=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B48<(2*n), B48+1,\"\")","v":""},{"$f":"IF(B49<>\"\",C48+hh/2,\"\")","v":""},"",{"$f":"IF(B50=\"\",IF(B49=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B49<(2*n), B49+1,\"\")","v":""},{"$f":"IF(B50<>\"\",C49+hh/2,\"\")","v":""},"",{"$f":"IF(B50=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B50<(2*n), B50+1,\"\")","v":""},{"$f":"IF(B51<>\"\",C50+hh/2,\"\")","v":""},"",{"$f":"IF(B52=\"\",IF(B51=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B51<(2*n), B51+1,\"\")","v":""},{"$f":"IF(B52<>\"\",C51+hh/2,\"\")","v":""},"",{"$f":"IF(B52=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B52<(2*n), B52+1,\"\")","v":""},{"$f":"IF(B53<>\"\",C52+hh/2,\"\")","v":""},"",{"$f":"IF(B54=\"\",IF(B53=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B53<(2*n), B53+1,\"\")","v":""},{"$f":"IF(B54<>\"\",C53+hh/2,\"\")","v":""},"",{"$f":"IF(B54=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B54<(2*n), B54+1,\"\")","v":""},{"$f":"IF(B55<>\"\",C54+hh/2,\"\")","v":""},"",{"$f":"IF(B56=\"\",IF(B55=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B55<(2*n), B55+1,\"\")","v":""},{"$f":"IF(B56<>\"\",C55+hh/2,\"\")","v":""},"",{"$f":"IF(B56=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B56<(2*n), B56+1,\"\")","v":""},{"$f":"IF(B57<>\"\",C56+hh/2,\"\")","v":""},"",{"$f":"IF(B58=\"\",IF(B57=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B57<(2*n), B57+1,\"\")","v":""},{"$f":"IF(B58<>\"\",C57+hh/2,\"\")","v":""},"",{"$f":"IF(B58=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B58<(2*n), B58+1,\"\")","v":""},{"$f":"IF(B59<>\"\",C58+hh/2,\"\")","v":""},"",{"$f":"IF(B60=\"\",IF(B59=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B59<(2*n), B59+1,\"\")","v":""},{"$f":"IF(B60<>\"\",C59+hh/2,\"\")","v":""},"",{"$f":"IF(B60=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B60<(2*n), B60+1,\"\")","v":""},{"$f":"IF(B61<>\"\",C60+hh/2,\"\")","v":""},"",{"$f":"IF(B62=\"\",IF(B61=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B61<(2*n), B61+1,\"\")","v":""},{"$f":"IF(B62<>\"\",C61+hh/2,\"\")","v":""},"",{"$f":"IF(B62=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B62<(2*n), B62+1,\"\")","v":""},{"$f":"IF(B63<>\"\",C62+hh/2,\"\")","v":""},"",{"$f":"IF(B64=\"\",IF(B63=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B63<(2*n), B63+1,\"\")","v":""},{"$f":"IF(B64<>\"\",C63+hh/2,\"\")","v":""},"",{"$f":"IF(B64=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B64<(2*n), B64+1,\"\")","v":""},{"$f":"IF(B65<>\"\",C64+hh/2,\"\")","v":""},"",{"$f":"IF(B66=\"\",IF(B65=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B65<(2*n), B65+1,\"\")","v":""},{"$f":"IF(B66<>\"\",C65+hh/2,\"\")","v":""},"",{"$f":"IF(B66=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B66<(2*n), B66+1,\"\")","v":""},{"$f":"IF(B67<>\"\",C66+hh/2,\"\")","v":""},"",{"$f":"IF(B68=\"\",IF(B67=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B67<(2*n), B67+1,\"\")","v":""},{"$f":"IF(B68<>\"\",C67+hh/2,\"\")","v":""},"",{"$f":"IF(B68=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B68<(2*n), B68+1,\"\")","v":""},{"$f":"IF(B69<>\"\",C68+hh/2,\"\")","v":""},"",{"$f":"IF(B70=\"\",IF(B69=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B69<(2*n), B69+1,\"\")","v":""},{"$f":"IF(B70<>\"\",C69+hh/2,\"\")","v":""},"",{"$f":"IF(B70=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B70<(2*n), B70+1,\"\")","v":""},{"$f":"IF(B71<>\"\",C70+hh/2,\"\")","v":""},"",{"$f":"IF(B72=\"\",IF(B71=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B71<(2*n), B71+1,\"\")","v":""},{"$f":"IF(B72<>\"\",C71+hh/2,\"\")","v":""},"",{"$f":"IF(B72=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B72<(2*n), B72+1,\"\")","v":""},{"$f":"IF(B73<>\"\",C72+hh/2,\"\")","v":""},"",{"$f":"IF(B74=\"\",IF(B73=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B73<(2*n), B73+1,\"\")","v":""},{"$f":"IF(B74<>\"\",C73+hh/2,\"\")","v":""},"",{"$f":"IF(B74=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B74<(2*n), B74+1,\"\")","v":""},{"$f":"IF(B75<>\"\",C74+hh/2,\"\")","v":""},"",{"$f":"IF(B76=\"\",IF(B75=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B75<(2*n), B75+1,\"\")","v":""},{"$f":"IF(B76<>\"\",C75+hh/2,\"\")","v":""},"",{"$f":"IF(B76=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B76<(2*n), B76+1,\"\")","v":""},{"$f":"IF(B77<>\"\",C76+hh/2,\"\")","v":""},"",{"$f":"IF(B78=\"\",IF(B77=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B77<(2*n), B77+1,\"\")","v":""},{"$f":"IF(B78<>\"\",C77+hh/2,\"\")","v":""},"",{"$f":"IF(B78=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B78<(2*n), B78+1,\"\")","v":""},{"$f":"IF(B79<>\"\",C78+hh/2,\"\")","v":""},"",{"$f":"IF(B80=\"\",IF(B79=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B79<(2*n), B79+1,\"\")","v":""},{"$f":"IF(B80<>\"\",C79+hh/2,\"\")","v":""},"",{"$f":"IF(B80=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B80<(2*n), B80+1,\"\")","v":""},{"$f":"IF(B81<>\"\",C80+hh/2,\"\")","v":""},"",{"$f":"IF(B82=\"\",IF(B81=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B81<(2*n), B81+1,\"\")","v":""},{"$f":"IF(B82<>\"\",C81+hh/2,\"\")","v":""},"",{"$f":"IF(B82=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B82<(2*n), B82+1,\"\")","v":""},{"$f":"IF(B83<>\"\",C82+hh/2,\"\")","v":""},"",{"$f":"IF(B84=\"\",IF(B83=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B83<(2*n), B83+1,\"\")","v":""},{"$f":"IF(B84<>\"\",C83+hh/2,\"\")","v":""},"",{"$f":"IF(B84=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B84<(2*n), B84+1,\"\")","v":""},{"$f":"IF(B85<>\"\",C84+hh/2,\"\")","v":""},{"$f":"IF(B85<>\"\",f(C85),\"\")","v":""},{"$f":"IF(B86=\"\",IF(B85=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B85<(2*n), B85+1,\"\")","v":""},{"$f":"IF(B86<>\"\",C85+hh/2,\"\")","v":""},"",{"$f":"IF(B86=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B86<(2*n), B86+1,\"\")","v":""},{"$f":"IF(B87<>\"\",C86+hh/2,\"\")","v":""},"",{"$f":"IF(B88=\"\",IF(B87=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B87<(2*n), B87+1,\"\")","v":""},{"$f":"IF(B88<>\"\",C87+hh/2,\"\")","v":""},"",{"$f":"IF(B88=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B88<(2*n), B88+1,\"\")","v":""},{"$f":"IF(B89<>\"\",C88+hh/2,\"\")","v":""},"",{"$f":"IF(B90=\"\",IF(B89=\"\",\"\",1),2)","v":""},{"$f":"IF(D89=\"\",\"\",E89*D89)","v":""}]
[null,{"$f":"IF(B89<(2*n), B89+1,\"\")","v":""},{"$f":"IF(B90<>\"\",C89+hh/2,\"\")","v":""},"",{"$f":"IF(B90=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B90<(2*n), B90+1,\"\")","v":""},{"$f":"IF(B91<>\"\",C90+hh/2,\"\")","v":""},"",{"$f":"IF(B92=\"\",IF(B91=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B91<(2*n), B91+1,\"\")","v":""},{"$f":"IF(B92<>\"\",C91+hh/2,\"\")","v":""},"",{"$f":"IF(B92=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B92<(2*n), B92+1,\"\")","v":""},{"$f":"IF(B93<>\"\",C92+hh/2,\"\")","v":""},"",{"$f":"IF(B94=\"\",IF(B93=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B93<(2*n), B93+1,\"\")","v":""},{"$f":"IF(B94<>\"\",C93+hh/2,\"\")","v":""},"",{"$f":"IF(B94=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B94<(2*n), B94+1,\"\")","v":""},{"$f":"IF(B95<>\"\",C94+hh/2,\"\")","v":""},"",{"$f":"IF(B96=\"\",IF(B95=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B95<(2*n), B95+1,\"\")","v":""},{"$f":"IF(B96<>\"\",C95+hh/2,\"\")","v":""},"",{"$f":"IF(B96=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B96<(2*n), B96+1,\"\")","v":""},{"$f":"IF(B97<>\"\",C96+hh/2,\"\")","v":""},"",{"$f":"IF(B98=\"\",IF(B97=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B97<(2*n), B97+1,\"\")","v":""},{"$f":"IF(B98<>\"\",C97+hh/2,\"\")","v":""},"",{"$f":"IF(B98=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B98<(2*n), B98+1,\"\")","v":""},{"$f":"IF(B99<>\"\",C98+hh/2,\"\")","v":""},"",{"$f":"IF(B100=\"\",IF(B99=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B99<(2*n), B99+1,\"\")","v":""},{"$f":"IF(B100<>\"\",C99+hh/2,\"\")","v":""},"",{"$f":"IF(B100=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B100<(2*n), B100+1,\"\")","v":""},{"$f":"IF(B101<>\"\",C100+hh/2,\"\")","v":""},"",{"$f":"IF(B102=\"\",IF(B101=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B101<(2*n), B101+1,\"\")","v":""},{"$f":"IF(B102<>\"\",C101+hh/2,\"\")","v":""},"",{"$f":"IF(B102=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B102<(2*n), B102+1,\"\")","v":""},{"$f":"IF(B103<>\"\",C102+hh/2,\"\")","v":""},"",{"$f":"IF(B104=\"\",IF(B103=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B103<(2*n), B103+1,\"\")","v":""},{"$f":"IF(B104<>\"\",C103+hh/2,\"\")","v":""},"",{"$f":"IF(B104=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B104<(2*n), B104+1,\"\")","v":""},{"$f":"IF(B105<>\"\",C104+hh/2,\"\")","v":""},"",{"$f":"IF(B106=\"\",IF(B105=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B105<(2*n), B105+1,\"\")","v":""},{"$f":"IF(B106<>\"\",C105+hh/2,\"\")","v":""},"",{"$f":"IF(B106=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B106<(2*n), B106+1,\"\")","v":""},{"$f":"IF(B107<>\"\",C106+hh/2,\"\")","v":""},"",{"$f":"IF(B108=\"\",IF(B107=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B107<(2*n), B107+1,\"\")","v":""},{"$f":"IF(B108<>\"\",C107+hh/2,\"\")","v":""},"",{"$f":"IF(B108=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B108<(2*n), B108+1,\"\")","v":""},{"$f":"IF(B109<>\"\",C108+hh/2,\"\")","v":""},"",{"$f":"IF(B110=\"\",IF(B109=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B109<(2*n), B109+1,\"\")","v":""},{"$f":"IF(B110<>\"\",C109+hh/2,\"\")","v":""},"",{"$f":"IF(B110=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B110<(2*n), B110+1,\"\")","v":""},{"$f":"IF(B111<>\"\",C110+hh/2,\"\")","v":""},"",{"$f":"IF(B112=\"\",IF(B111=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B111<(2*n), B111+1,\"\")","v":""},{"$f":"IF(B112<>\"\",C111+hh/2,\"\")","v":""},"",{"$f":"IF(B112=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B112<(2*n+1), B112+1,\"\")","v":""},{"$f":"IF(B113<>\"\",C112+hh/2,\"\")","v":""},"",{"$f":"IF(B114=\"\",IF(B113=\"\",\"\",1),2)","v":""},""]
[null,{"$f":"IF(B113<n, B113+1,\"\")","v":""},{"$f":"IF(B114<>\"\",C113+hh/2,\"\")","v":""},"",{"$f":"IF(B114=\"\",\"\",4)","v":""},""]
[null,"",{"$f":"IF(B115<>\"\",C114+hh/2,\"\")","v":""},"",{"$f":"IF(B116=\"\",IF(B115=\"\",\"\",1),2)","v":""},""]
[null,"",{"$f":"IF(B116<>\"\",C115+hh/2,\"\")","v":""},"",{"$f":"IF(B116=\"\",\"\",4)","v":""},""]
[null,{"$f":"IF(B116<n, B116+1,\"\")","v":""},{"$f":"IF(B117<>\"\",C116+hh/2,\"\")","v":""},"",null,""]
[null,"",{"$f":"IF(B118<>\"\",C117+hh/2,\"\")","v":""},"",null,""]
[null,"",{"$f":"IF(B119<>\"\",C118+hh/2,\"\")","v":""},""]
[null,"",{"$f":"IF(B120<>\"\",C119+hh/2,\"\")","v":""},""]
[null,"",{"$f":"IF(B121<>\"\",C120+hh/2,\"\")","v":""},""]
[null,"",{"$f":"IF(B122<>\"\",C121+hh,\"\")","v":""},""]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}